Overview

Dataset statistics

Number of variables	26
Number of observations	180463
Missing cells	294968
Missing cells (%)	6.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	34.4 MiB
Average record size in memory	200.0 B

Variable types

Numeric	7
DateTime	4
Text	7
Categorical	6
Unsupported	2

Alerts

`facility_type` has constant value "DSNY Garage"	Constant
`Request_Closing_Time_in_Hours` is highly overall correlated with `days_to_close`	High correlation
`borough` is highly overall correlated with `city` and 4 other fields	High correlation
`city` is highly overall correlated with `borough` and 4 other fields	High correlation
`days_to_close` is highly overall correlated with `Request_Closing_Time_in_Hours`	High correlation
`geo_status` is highly overall correlated with `latitude` and 2 other fields	High correlation
`incident_zip` is highly overall correlated with `borough` and 3 other fields	High correlation
`latitude` is highly overall correlated with `borough` and 3 other fields	High correlation
`longitude` is highly overall correlated with `borough` and 3 other fields	High correlation
`zip_codes` is highly overall correlated with `borough` and 4 other fields	High correlation
`status` is highly imbalanced (90.4%)	Imbalance
`geo_status` is highly imbalanced (78.6%)	Imbalance
`resolution_date_update` has 1908 (1.1%) missing values	Missing
`resolution_description` has 5306 (2.9%) missing values	Missing
`descriptor` has 4634 (2.6%) missing values	Missing
`location_type` has 51464 (28.5%) missing values	Missing
`incident_zip` has 4964 (2.8%) missing values	Missing
`incident_address` has 10619 (5.9%) missing values	Missing
`city` has 13839 (7.7%) missing values	Missing
`facility_type` has 174232 (96.5%) missing values	Missing
`latitude` has 6143 (3.4%) missing values	Missing
`longitude` has 6143 (3.4%) missing values	Missing
`location` has 6143 (3.4%) missing values	Missing
`zip_codes` has 8411 (4.7%) missing values	Missing
`unique_key` has unique values	Unique
`Request_Closing_Time` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Request_Closing_Time_in_Seconds` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`days_to_close` has 8058 (4.5%) zeros	Zeros

Reproduction

Analysis started	2026-01-11 14:12:58.966211
Analysis finished	2026-01-11 14:13:29.292310
Duration	30.33 seconds
Software version	ydata-profiling vv4.18.0
Download configuration	config.json

unique_key
Real number (ℝ)

Unique

Distinct	180463
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44593541

Minimum	43859987
Maximum	45054995
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 MiB

Quantile statistics

Minimum	43859987
5-th percentile	43944366
Q1	44159886
median	44884510
Q3	44953045
95-th percentile	45033377
Maximum	45054995
Range	1195008
Interquartile range (IQR)	793159.5

Descriptive statistics

Standard deviation	420523.01
Coefficient of variation (CV)	0.0094301327
Kurtosis	-1.5586873
Mean	44593541
Median Absolute Deviation (MAD)	150981
Skewness	-0.42679626
Sum	8.0474842 × 10¹²
Variance	1.768396 × 10¹¹
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
45054995	1	< 0.1%
43859987	1	< 0.1%
43859988	1	< 0.1%
43859989	1	< 0.1%
43859990	1	< 0.1%
43859991	1	< 0.1%
43860006	1	< 0.1%
43860007	1	< 0.1%
43860023	1	< 0.1%
43860038	1	< 0.1%
Other values (180453)	180453	> 99.9%

Value	Count	Frequency (%)
43859987	1	< 0.1%
43859988	1	< 0.1%
43859989	1	< 0.1%
43859990	1	< 0.1%
43859991	1	< 0.1%
43860006	1	< 0.1%
43860007	1	< 0.1%
43860023	1	< 0.1%
43860038	1	< 0.1%
43860039	1	< 0.1%

Value	Count	Frequency (%)
45054995	1	< 0.1%
45054994	1	< 0.1%
45054993	1	< 0.1%
45054992	1	< 0.1%
45054991	1	< 0.1%
45054981	1	< 0.1%
45054980	1	< 0.1%
45054958	1	< 0.1%
45054956	1	< 0.1%
45054955	1	< 0.1%

created_at
Date

Distinct	161176
Distinct (%)	89.3%
Missing	0
Missing (%)	0.0%
Memory size	2.8 MiB

Minimum	2019-09-22 11:38:28
Maximum	2019-12-01 01:48:45
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

closed_at
Date

Distinct	125852
Distinct (%)	69.7%
Missing	0
Missing (%)	0.0%
Memory size	2.8 MiB

Minimum	2019-09-20 11:08:00
Maximum	2019-12-01 01:59:50
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

resolution_date_update
Date

Missing

Distinct	119935
Distinct (%)	67.2%
Missing	1908
Missing (%)	1.1%
Memory size	2.8 MiB

Minimum	2019-09-20 11:08:00
Maximum	2019-12-01 06:59:42
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

resolution_description
Text

Missing

Distinct	339
Distinct (%)	0.2%
Missing	5306
Missing (%)	2.9%
Memory size	2.8 MiB

Length

Max length	345
Median length	325
Mean length	146.93671
Min length	26

Characters and Unicode

Total characters	25736993
Distinct characters	74
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	55 ?
Unique (%)	< 0.1%

Sample

1st row	After performing a thorough search, the Department of Transportation was unable to find the lost ite
2nd row	The Police Department responded and upon arrival those responsible for the condition were gone.
3rd row	The agency was unable to respond to this complaint because they allocated resources to other critica
4th row	The Department of Sanitation removed the items.
5th row	The Department of Sanitation removed the items.

Value	Count	Frequency (%)
the	456010	12.1%
complaint	169156	4.5%
and	155226	4.1%
department	152202	4.0%
to	144117	3.8%
of	140993	3.7%
a	101372	2.7%
police	93698	2.5%
condition	88041	2.3%
responded	80463	2.1%
Other values (722)	2190985	58.1%

Most occurring characters

Value	Count	Frequency (%)
	3602558	14.0%
e	2426994	9.4%
t	2046052	7.9%
o	1948060	7.6%
n	1790879	7.0%
i	1690257	6.6%
a	1523465	5.9%
r	984641	3.8%
d	927720	3.6%
l	884659	3.4%
Other values (64)	7911708	30.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	25736993	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	3602558	14.0%
e	2426994	9.4%
t	2046052	7.9%
o	1948060	7.6%
n	1790879	7.0%
i	1690257	6.6%
a	1523465	5.9%
r	984641	3.8%
d	927720	3.6%
l	884659	3.4%
Other values (64)	7911708	30.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	25736993	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	3602558	14.0%
e	2426994	9.4%
t	2046052	7.9%
o	1948060	7.6%
n	1790879	7.0%
i	1690257	6.6%
a	1523465	5.9%
r	984641	3.8%
d	927720	3.6%
l	884659	3.4%
Other values (64)	7911708	30.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	25736993	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	3602558	14.0%
e	2426994	9.4%
t	2046052	7.9%
o	1948060	7.6%
n	1790879	7.0%
i	1690257	6.6%
a	1523465	5.9%
r	984641	3.8%
d	927720	3.6%
l	884659	3.4%
Other values (64)	7911708	30.7%

days_to_close
Real number (ℝ)

High correlation Zeros

Distinct	110535
Distinct (%)	61.6%
Missing	1162
Missing (%)	0.6%
Infinite	0
Infinite (%)	0.0%
Mean	2.1059367

Minimum	0
Maximum	67.435093
Zeros	8058
Zeros (%)	4.5%
Negative	0
Negative (%)	0.0%
Memory size	2.8 MiB

Quantile statistics

Minimum	0
5-th percentile	0.0011342592
Q1	0.084027778
median	0.34159722
Q3	1.9451389
95-th percentile	10.143484
Maximum	67.435093
Range	67.435093
Interquartile range (IQR)	1.8611111

Descriptive statistics

Standard deviation	5.0419995
Coefficient of variation (CV)	2.3941838
Kurtosis	38.441994
Mean	2.1059367
Median Absolute Deviation (MAD)	0.32822917
Skewness	5.3403008
Sum	377596.55
Variance	25.421759
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8058	4.5%
1.15740113 × 10^-5	127	0.1%
0.001388888806	106	0.1%
2.314802259 × 10^-5	105	0.1%
0.0006944444031	104	0.1%
0.02083333349	70	< 0.1%
0.002083333209	64	< 0.1%
0.007638888899	63	< 0.1%
0.05347222229	63	< 0.1%
0.03125	60	< 0.1%
Other values (110525)	170481	94.5%
(Missing)	1162	0.6%

Value	Count	Frequency (%)
0	8058	4.5%
1.15740113 × 10^-5	127	0.1%
1.157447696 × 10^-5	32	< 0.1%
2.314802259 × 10^-5	105	0.1%
2.314848825 × 10^-5	41	< 0.1%
3.472203389 × 10^-5	53	< 0.1%
3.472249955 × 10^-5	25	< 0.1%
4.629604518 × 10^-5	11	< 0.1%
4.629651085 × 10^-5	22	< 0.1%
5.787005648 × 10^-5	11	< 0.1%

Value	Count	Frequency (%)
67.43509259	1	< 0.1%
67.3041088	1	< 0.1%
67.04428241	1	< 0.1%
66.14087963	1	< 0.1%
66.0337963	1	< 0.1%
65.95501157	1	< 0.1%
65.93793981	1	< 0.1%
65.91928241	1	< 0.1%
65.86940972	1	< 0.1%
65.67532407	1	< 0.1%

agency
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.8 MiB

NYPD	82846
HPD	39310
DOT	17548
DEP	12559
DSNY	9568
Other values (9)	18632

Length

Max length	5
Median length	4
Mean length	3.5355558
Min length	3

Characters and Unicode

Total characters	638037
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DOT
2nd row	NYPD
3rd row	DOHMH
4th row	EDC
5th row	DPR

Common Values

Value	Count	Frequency (%)
NYPD	82846	45.9%
HPD	39310	21.8%
DOT	17548	9.7%
DEP	12559	7.0%
DSNY	9568	5.3%
DOB	8989	5.0%
DHS	2665	1.5%
DPR	2160	1.2%
DOHMH	2107	1.2%
TLC	1554	0.9%
Other values (4)	1157	0.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
nypd	82846	45.9%
hpd	39310	21.8%
dot	17548	9.7%
dep	12559	7.0%
dsny	9568	5.3%
dob	8989	5.0%
dhs	2665	1.5%
dpr	2160	1.2%
dohmh	2107	1.2%
tlc	1554	0.9%
Other values (4)	1157	0.6%

Most occurring characters

Value	Count	Frequency (%)
D	178909	28.0%
P	136875	21.5%
Y	92414	14.5%
N	92414	14.5%
H	46189	7.2%
O	28741	4.5%
T	19122	3.0%
E	13108	2.1%
S	12233	1.9%
B	8989	1.4%
Other values (6)	9043	1.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	638037	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
D	178909	28.0%
P	136875	21.5%
Y	92414	14.5%
N	92414	14.5%
H	46189	7.2%
O	28741	4.5%
T	19122	3.0%
E	13108	2.1%
S	12233	1.9%
B	8989	1.4%
Other values (6)	9043	1.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	638037	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
D	178909	28.0%
P	136875	21.5%
Y	92414	14.5%
N	92414	14.5%
H	46189	7.2%
O	28741	4.5%
T	19122	3.0%
E	13108	2.1%
S	12233	1.9%
B	8989	1.4%
Other values (6)	9043	1.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	638037	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
D	178909	28.0%
P	136875	21.5%
Y	92414	14.5%
N	92414	14.5%
H	46189	7.2%
O	28741	4.5%
T	19122	3.0%
E	13108	2.1%
S	12233	1.9%
B	8989	1.4%
Other values (6)	9043	1.4%

agency_name
Text

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.8 MiB

Length

Max length	59
Median length	54
Mean length	34.319556
Min length	8

Characters and Unicode

Total characters	6193410
Distinct characters	52
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Department of Transportation
2nd row	New York City Police Department
3rd row	Department of Health and Mental Hygiene
4th row	Economic Development Corporation
5th row	Department of Parks and Recreation

Value	Count	Frequency (%)
department	168884	19.6%
of	86038	10.0%
new	82846	9.6%
york	82846	9.6%
police	82846	9.6%
city	82846	9.6%
and	45426	5.3%
development	39772	4.6%
preservation	39310	4.6%
housing	39310	4.6%
Other values (58)	109518	12.7%

Most occurring characters

Value	Count	Frequency (%)
e	760603	12.3%
	679179	11.0%
t	589649	9.5%
o	467373	7.5%
n	451053	7.3%
r	405969	6.6%
i	321937	5.2%
a	319918	5.2%
m	229654	3.7%
p	226666	3.7%
Other values (42)	1741409	28.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6193410	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	760603	12.3%
	679179	11.0%
t	589649	9.5%
o	467373	7.5%
n	451053	7.3%
r	405969	6.6%
i	321937	5.2%
a	319918	5.2%
m	229654	3.7%
p	226666	3.7%
Other values (42)	1741409	28.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6193410	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	760603	12.3%
	679179	11.0%
t	589649	9.5%
o	467373	7.5%
n	451053	7.3%
r	405969	6.6%
i	321937	5.2%
a	319918	5.2%
m	229654	3.7%
p	226666	3.7%
Other values (42)	1741409	28.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6193410	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	760603	12.3%
	679179	11.0%
t	589649	9.5%
o	467373	7.5%
n	451053	7.3%
r	405969	6.6%
i	321937	5.2%
a	319918	5.2%
m	229654	3.7%
p	226666	3.7%
Other values (42)	1741409	28.1%

complaint_type
Text

Distinct	128
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.8 MiB

Length

Max length	39
Median length	33
Mean length	16.640652
Min length	4

Characters and Unicode

Total characters	3003022
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	< 0.1%

Sample

1st row	Ferry Inquiry
2nd row	Drinking
3rd row	Rodent
4th row	Noise - Helicopter
5th row	Violation of Park Rules

Value	Count	Frequency (%)
noise	43657	10.7%
	39805	9.8%
water	37081	9.1%
heat/hot	31824	7.8%
residential	23746	5.8%
parking	22067	5.4%
illegal	20462	5.0%
condition	17022	4.2%
blocked	14904	3.7%
driveway	14904	3.7%
Other values (171)	141717	34.8%

Most occurring characters

Value	Count	Frequency (%)
e	297726	9.9%
i	244223	8.1%
	226726	7.5%
l	173510	5.8%
a	141938	4.7%
n	140541	4.7%
o	140502	4.7%
t	130525	4.3%
s	120167	4.0%
T	109628	3.7%
Other values (44)	1277536	42.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3003022	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	297726	9.9%
i	244223	8.1%
	226726	7.5%
l	173510	5.8%
a	141938	4.7%
n	140541	4.7%
o	140502	4.7%
t	130525	4.3%
s	120167	4.0%
T	109628	3.7%
Other values (44)	1277536	42.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3003022	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	297726	9.9%
i	244223	8.1%
	226726	7.5%
l	173510	5.8%
a	141938	4.7%
n	140541	4.7%
o	140502	4.7%
t	130525	4.3%
s	120167	4.0%
T	109628	3.7%
Other values (44)	1277536	42.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3003022	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	297726	9.9%
i	244223	8.1%
	226726	7.5%
l	173510	5.8%
a	141938	4.7%
n	140541	4.7%
o	140502	4.7%
t	130525	4.3%
s	120167	4.0%
T	109628	3.7%
Other values (44)	1277536	42.5%

descriptor
Text

Missing

Distinct	622
Distinct (%)	0.4%
Missing	4634
Missing (%)	2.6%
Memory size	2.8 MiB

Length

Max length	80
Median length	71
Mean length	18.219395
Min length	3

Characters and Unicode

Total characters	3203498
Distinct characters	73
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	79 ?
Unique (%)	< 0.1%

Sample

1st row	Lost and Found
2nd row	In Public
3rd row	Rat Sighting
4th row	Other
5th row	Smoking

Value	Count	Frequency (%)
loud	26967	6.1%
building	23538	5.3%
music/party	22505	5.1%
entire	21170	4.8%
access	14904	3.4%
no	12568	2.8%
only	10808	2.4%
apartment	10804	2.4%
blocked	10559	2.4%
	8274	1.9%
Other values (944)	280049	63.3%

Most occurring characters

Value	Count	Frequency (%)
	266434	8.3%
e	204755	6.4%
i	189936	5.9%
o	159751	5.0%
t	146373	4.6%
n	143890	4.5%
r	132943	4.1%
a	130962	4.1%
s	116060	3.6%
c	112489	3.5%
Other values (63)	1599905	49.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3203498	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	266434	8.3%
e	204755	6.4%
i	189936	5.9%
o	159751	5.0%
t	146373	4.6%
n	143890	4.5%
r	132943	4.1%
a	130962	4.1%
s	116060	3.6%
c	112489	3.5%
Other values (63)	1599905	49.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3203498	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	266434	8.3%
e	204755	6.4%
i	189936	5.9%
o	159751	5.0%
t	146373	4.6%
n	143890	4.5%
r	132943	4.1%
a	130962	4.1%
s	116060	3.6%
c	112489	3.5%
Other values (63)	1599905	49.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3203498	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	266434	8.3%
e	204755	6.4%
i	189936	5.9%
o	159751	5.0%
t	146373	4.6%
n	143890	4.5%
r	132943	4.1%
a	130962	4.1%
s	116060	3.6%
c	112489	3.5%
Other values (63)	1599905	49.9%

location_type
Text

Missing

Distinct	83
Distinct (%)	0.1%
Missing	51464
Missing (%)	28.5%
Memory size	2.8 MiB

Length

Max length	29
Median length	28
Mean length	17.319297
Min length	3

Characters and Unicode

Total characters	2234172
Distinct characters	53
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16 ?
Unique (%)	< 0.1%

Sample

1st row	Bridge
2nd row	Street/Sidewalk
3rd row	Street Area
4th row	Above Address
5th row	Park

Value	Count	Frequency (%)
residential	60052	30.8%
street/sidewalk	43152	22.1%
building	40611	20.8%
building/house	20630	10.6%
street	7854	4.0%
sidewalk	7054	3.6%
store/commercial	3006	1.5%
family	1494	0.8%
club/bar/restaurant	1367	0.7%
3	833	0.4%
Other values (93)	9091	4.7%

Most occurring characters

Value	Count	Frequency (%)
e	228529	10.2%
I	157240	7.0%
S	144541	6.5%
i	143318	6.4%
t	131964	5.9%
l	101264	4.5%
d	95052	4.3%
a	83175	3.7%
L	79750	3.6%
D	79279	3.5%
Other values (43)	990060	44.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2234172	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	228529	10.2%
I	157240	7.0%
S	144541	6.5%
i	143318	6.4%
t	131964	5.9%
l	101264	4.5%
d	95052	4.3%
a	83175	3.7%
L	79750	3.6%
D	79279	3.5%
Other values (43)	990060	44.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2234172	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	228529	10.2%
I	157240	7.0%
S	144541	6.5%
i	143318	6.4%
t	131964	5.9%
l	101264	4.5%
d	95052	4.3%
a	83175	3.7%
L	79750	3.6%
D	79279	3.5%
Other values (43)	990060	44.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2234172	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	228529	10.2%
I	157240	7.0%
S	144541	6.5%
i	143318	6.4%
t	131964	5.9%
l	101264	4.5%
d	95052	4.3%
a	83175	3.7%
L	79750	3.6%
D	79279	3.5%
Other values (43)	990060	44.3%

incident_zip
Real number (ℝ)

High correlation Missing

Distinct	220
Distinct (%)	0.1%
Missing	4964
Missing (%)	2.8%
Infinite	0
Infinite (%)	0.0%
Mean	10809.206

Minimum	10000
Maximum	12345
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	10000
5-th percentile	10011
Q1	10309
median	11203
Q3	11235
95-th percentile	11422
Maximum	12345
Range	2345
Interquartile range (IQR)	926

Descriptive statistics

Standard deviation	549.61896
Coefficient of variation (CV)	0.050847301
Kurtosis	-1.5813326
Mean	10809.206
Median Absolute Deviation (MAD)	220
Skewness	-0.305071
Sum	1.8970049 × 10⁹
Variance	302080.97
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11226	3246	1.8%
11385	2874	1.6%
10467	2725	1.5%
10457	2119	1.2%
10468	2097	1.2%
10453	2096	1.2%
10452	2049	1.1%
11221	1975	1.1%
11207	1963	1.1%
10458	1951	1.1%
Other values (210)	152404	84.5%
(Missing)	4964	2.8%

Value	Count	Frequency (%)
10000	14	< 0.1%
10001	923	0.5%
10002	1635	0.9%
10003	1496	0.8%
10004	380	0.2%
10005	307	0.2%
10006	127	0.1%
10007	450	0.2%
10009	1371	0.8%
10010	659	0.4%

Value	Count	Frequency (%)
12345	1	< 0.1%
11697	11	< 0.1%
11694	454	0.3%
11693	201	0.1%
11692	382	0.2%
11691	997	0.6%
11436	511	0.3%
11435	1045	0.6%
11434	994	0.6%
11433	787	0.4%

incident_address
Text

Missing

Distinct	81684
Distinct (%)	48.1%
Missing	10619
Missing (%)	5.9%
Memory size	2.8 MiB

Length

Max length	38
Median length	35
Mean length	17.738613
Min length	3

Characters and Unicode

Total characters	3012797
Distinct characters	51
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	55165 ?
Unique (%)	32.5%

Sample

1st row	SAINT GEORGE FERRY
2nd row	600 RIDGEWOOD AVENUE
3rd row	11 GREENE STREET
4th row	101-21 75 ROAD
5th row	60-09 SAINT FELIX AVENUE

Value	Count	Frequency (%)
street	75214	13.9%
avenue	64660	12.0%
east	18061	3.3%
west	13940	2.6%
boulevard	6054	1.1%
place	5536	1.0%
road	5513	1.0%
broadway	2369	0.4%
parkway	2258	0.4%
park	1986	0.4%
Other values (18402)	344867	63.8%

Most occurring characters

Value	Count	Frequency (%)
	422670	14.0%
E	400231	13.3%
T	227882	7.6%
A	171349	5.7%
R	157267	5.2%
S	150751	5.0%
1	142421	4.7%
N	129924	4.3%
2	90632	3.0%
U	89709	3.0%
Other values (41)	1029961	34.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	3012797	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	422670	14.0%
E	400231	13.3%
T	227882	7.6%
A	171349	5.7%
R	157267	5.2%
S	150751	5.0%
1	142421	4.7%
N	129924	4.3%
2	90632	3.0%
U	89709	3.0%
Other values (41)	1029961	34.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	3012797	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	422670	14.0%
E	400231	13.3%
T	227882	7.6%
A	171349	5.7%
R	157267	5.2%
S	150751	5.0%
1	142421	4.7%
N	129924	4.3%
2	90632	3.0%
U	89709	3.0%
Other values (41)	1029961	34.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	3012797	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	422670	14.0%
E	400231	13.3%
T	227882	7.6%
A	171349	5.7%
R	157267	5.2%
S	150751	5.0%
1	142421	4.7%
N	129924	4.3%
2	90632	3.0%
U	89709	3.0%
Other values (41)	1029961	34.2%

city
Categorical

High correlation Missing

Distinct	48
Distinct (%)	< 0.1%
Missing	13839
Missing (%)	7.7%
Memory size	2.8 MiB

BROOKLYN	50866
NEW YORK	36334
BRONX	31511
STATEN ISLAND	7270
JAMAICA	4374
Other values (43)	36269

Length

Max length	19
Median length	8
Mean length	8.1980567
Min length	5

Characters and Unicode

Total characters	1365993
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	STATEN ISLAND
2nd row	BROOKLYN
3rd row	NEW YORK
4th row	FOREST HILLS
5th row	RIDGEWOOD

Common Values

Value	Count	Frequency (%)
BROOKLYN	50866	28.2%
NEW YORK	36334	20.1%
BRONX	31511	17.5%
STATEN ISLAND	7270	4.0%
JAMAICA	4374	2.4%
ASTORIA	3126	1.7%
FLUSHING	2886	1.6%
RIDGEWOOD	2731	1.5%
FRESH MEADOWS	1762	1.0%
CORONA	1618	0.9%
Other values (38)	24146	13.4%
(Missing)	13839	7.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
brooklyn	50866	22.0%
new	36368	15.7%
york	36334	15.7%
bronx	31511	13.6%
island	8527	3.7%
staten	7270	3.1%
jamaica	4374	1.9%
park	3444	1.5%
astoria	3126	1.3%
flushing	2886	1.2%
Other values (52)	46990	20.3%

Most occurring characters

Value	Count	Frequency (%)
O	205761	15.1%
N	153584	11.2%
R	144560	10.6%
K	94483	6.9%
Y	91244	6.7%
B	84379	6.2%
L	81437	6.0%
E	75614	5.5%
	65072	4.8%
A	58545	4.3%
Other values (17)	311314	22.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1365993	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
O	205761	15.1%
N	153584	11.2%
R	144560	10.6%
K	94483	6.9%
Y	91244	6.7%
B	84379	6.2%
L	81437	6.0%
E	75614	5.5%
	65072	4.8%
A	58545	4.3%
Other values (17)	311314	22.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1365993	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
O	205761	15.1%
N	153584	11.2%
R	144560	10.6%
K	94483	6.9%
Y	91244	6.7%
B	84379	6.2%
L	81437	6.0%
E	75614	5.5%
	65072	4.8%
A	58545	4.3%
Other values (17)	311314	22.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1365993	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
O	205761	15.1%
N	153584	11.2%
R	144560	10.6%
K	94483	6.9%
Y	91244	6.7%
B	84379	6.2%
L	81437	6.0%
E	75614	5.5%
	65072	4.8%
A	58545	4.3%
Other values (17)	311314	22.8%

facility_type
Categorical

Constant Missing

Distinct	1
Distinct (%)	< 0.1%
Missing	174232
Missing (%)	96.5%
Memory size	2.8 MiB

DSNY Garage	6231

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	68541
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DSNY Garage
2nd row	DSNY Garage
3rd row	DSNY Garage
4th row	DSNY Garage
5th row	DSNY Garage

Common Values

Value	Count	Frequency (%)
DSNY Garage	6231	3.5%
(Missing)	174232	96.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
dsny	6231	50.0%
garage	6231	50.0%

Most occurring characters

Value	Count	Frequency (%)
a	12462	18.2%
D	6231	9.1%
S	6231	9.1%
N	6231	9.1%
	6231	9.1%
Y	6231	9.1%
G	6231	9.1%
r	6231	9.1%
g	6231	9.1%
e	6231	9.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	68541	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	12462	18.2%
D	6231	9.1%
S	6231	9.1%
N	6231	9.1%
	6231	9.1%
Y	6231	9.1%
G	6231	9.1%
r	6231	9.1%
g	6231	9.1%
e	6231	9.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	68541	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	12462	18.2%
D	6231	9.1%
S	6231	9.1%
N	6231	9.1%
	6231	9.1%
Y	6231	9.1%
G	6231	9.1%
r	6231	9.1%
g	6231	9.1%
e	6231	9.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	68541	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	12462	18.2%
D	6231	9.1%
S	6231	9.1%
N	6231	9.1%
	6231	9.1%
Y	6231	9.1%
G	6231	9.1%
r	6231	9.1%
g	6231	9.1%
e	6231	9.1%

status
Categorical

Imbalance

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.8 MiB

Closed	175459
Open	2926
Pending	1211
Assigned	851
In Progress	16

Length

Max length	11
Median length	6
Mean length	5.9841574
Min length	4

Characters and Unicode

Total characters	1079919
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Closed
2nd row	Closed
3rd row	Closed
4th row	Closed
5th row	Closed

Common Values

Value	Count	Frequency (%)
Closed	175459	97.2%
Open	2926	1.6%
Pending	1211	0.7%
Assigned	851	0.5%
In Progress	16	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
closed	175459	97.2%
open	2926	1.6%
pending	1211	0.7%
assigned	851	0.5%
in	16	< 0.1%
progress	16	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	180463	16.7%
d	177521	16.4%
s	177193	16.4%
o	175475	16.2%
C	175459	16.2%
l	175459	16.2%
n	6215	0.6%
O	2926	0.3%
p	2926	0.3%
g	2078	0.2%
Other values (6)	4204	0.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1079919	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	180463	16.7%
d	177521	16.4%
s	177193	16.4%
o	175475	16.2%
C	175459	16.2%
l	175459	16.2%
n	6215	0.6%
O	2926	0.3%
p	2926	0.3%
g	2078	0.2%
Other values (6)	4204	0.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1079919	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	180463	16.7%
d	177521	16.4%
s	177193	16.4%
o	175475	16.2%
C	175459	16.2%
l	175459	16.2%
n	6215	0.6%
O	2926	0.3%
p	2926	0.3%
g	2078	0.2%
Other values (6)	4204	0.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1079919	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	180463	16.7%
d	177521	16.4%
s	177193	16.4%
o	175475	16.2%
C	175459	16.2%
l	175459	16.2%
n	6215	0.6%
O	2926	0.3%
p	2926	0.3%
g	2078	0.2%
Other values (6)	4204	0.4%

borough
Categorical

High correlation

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.8 MiB

BROOKLYN	53926
QUEENS	43817
MANHATTAN	40887
BRONX	33524
STATEN ISLAND	7661

Length

Max length	13
Median length	11
Mean length	7.4066928
Min length	5

Characters and Unicode

Total characters	1336634
Distinct characters	27
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	STATEN ISLAND
2nd row	BROOKLYN
3rd row	MANHATTAN
4th row	QUEENS
5th row	QUEENS

Common Values

Value	Count	Frequency (%)
BROOKLYN	53926	29.9%
QUEENS	43817	24.3%
MANHATTAN	40887	22.7%
BRONX	33524	18.6%
STATEN ISLAND	7661	4.2%
Unspecified	648	0.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
brooklyn	53926	28.7%
queens	43817	23.3%
manhattan	40887	21.7%
bronx	33524	17.8%
staten	7661	4.1%
island	7661	4.1%
unspecified	648	0.3%

Most occurring characters

Value	Count	Frequency (%)
N	228363	17.1%
O	141376	10.6%
A	137983	10.3%
T	97096	7.3%
E	95295	7.1%
R	87450	6.5%
B	87450	6.5%
L	61587	4.6%
S	59139	4.4%
Y	53926	4.0%
Other values (17)	286969	21.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1336634	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
N	228363	17.1%
O	141376	10.6%
A	137983	10.3%
T	97096	7.3%
E	95295	7.1%
R	87450	6.5%
B	87450	6.5%
L	61587	4.6%
S	59139	4.4%
Y	53926	4.0%
Other values (17)	286969	21.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1336634	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
N	228363	17.1%
O	141376	10.6%
A	137983	10.3%
T	97096	7.3%
E	95295	7.1%
R	87450	6.5%
B	87450	6.5%
L	61587	4.6%
S	59139	4.4%
Y	53926	4.0%
Other values (17)	286969	21.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1336634	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
N	228363	17.1%
O	141376	10.6%
A	137983	10.3%
T	97096	7.3%
E	95295	7.1%
R	87450	6.5%
B	87450	6.5%
L	61587	4.6%
S	59139	4.4%
Y	53926	4.0%
Other values (17)	286969	21.5%

latitude
Real number (ℝ)

High correlation Missing

Distinct	52733
Distinct (%)	30.3%
Missing	6143
Missing (%)	3.4%
Infinite	0
Infinite (%)	0.0%
Mean	40.732341

Minimum	40.49968
Maximum	40.912868
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	40.49968
5-th percentile	40.599769
Q1	40.671188
median	40.725382
Q3	40.807085
95-th percentile	40.86837
Maximum	40.912868
Range	0.41318893
Interquartile range (IQR)	0.13589668

Descriptive statistics

Standard deviation	0.084627748
Coefficient of variation (CV)	0.0020776549
Kurtosis	-0.84565002
Mean	40.732341
Median Absolute Deviation (MAD)	0.063064575
Skewness	0.041365333
Sum	7100461.6
Variance	0.0071618557
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.72195816	509	0.3%
40.74742126	429	0.2%
40.70380783	257	0.1%
40.67934036	181	0.1%
40.73009872	178	0.1%
40.74499893	175	0.1%
40.64831924	173	0.1%
40.85443878	150	0.1%
40.79013824	129	0.1%
40.77863312	126	0.1%
Other values (52723)	172013	95.3%
(Missing)	6143	3.4%

Value	Count	Frequency (%)
40.49967957	1	< 0.1%
40.49972153	1	< 0.1%
40.49975204	1	< 0.1%
40.49975967	1	< 0.1%
40.49983597	1	< 0.1%
40.4998436	1	< 0.1%
40.49990463	1	< 0.1%
40.49999619	1	< 0.1%
40.50003815	1	< 0.1%
40.50011063	1	< 0.1%

Value	Count	Frequency (%)
40.9128685	1	< 0.1%
40.912117	1	< 0.1%
40.9120636	1	< 0.1%
40.91166687	1	< 0.1%
40.91158676	3	< 0.1%
40.91139603	3	< 0.1%
40.91132355	1	< 0.1%
40.91103745	2	< 0.1%
40.91093445	2	< 0.1%
40.91091919	1	< 0.1%

longitude
Real number (ℝ)

High correlation Missing

Distinct	35627
Distinct (%)	20.4%
Missing	6143
Missing (%)	3.4%
Infinite	0
Infinite (%)	0.0%
Mean	-73.92448

Minimum	-74.253922
Maximum	-73.700722
Zeros	0
Zeros (%)	0.0%
Negative	174320
Negative (%)	96.6%
Memory size	2.1 MiB

Quantile statistics

Minimum	-74.253922
5-th percentile	-74.02636
Q1	-73.96978
median	-73.929028
Q3	-73.877975
95-th percentile	-73.788398
Maximum	-73.700722
Range	0.55319977
Interquartile range (IQR)	0.091804504

Descriptive statistics

Standard deviation	0.07897988
Coefficient of variation (CV)	-0.001068386
Kurtosis	1.539024
Mean	-73.92448
Median Absolute Deviation (MAD)	0.045524597
Skewness	-0.34315675
Sum	-12886515
Variance	0.0062378212
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.80970001	509	0.3%
-73.87685394	430	0.2%
-73.90311432	260	0.1%
-73.93043518	177	0.1%
-73.81090546	176	0.1%
-73.89296722	174	0.1%
-73.7882843	154	0.1%
-73.89842224	152	0.1%
-73.97097778	133	0.1%
-73.94981384	131	0.1%
Other values (35617)	172024	95.3%
(Missing)	6143	3.4%

Value	Count	Frequency (%)
-74.25392151	2	< 0.1%
-74.25376129	1	< 0.1%
-74.25319672	1	< 0.1%
-74.25318146	3	< 0.1%
-74.25315094	1	< 0.1%
-74.25313568	1	< 0.1%
-74.25255585	1	< 0.1%
-74.25144196	1	< 0.1%
-74.25099182	2	< 0.1%
-74.25046539	1	< 0.1%

Value	Count	Frequency (%)
-73.70072174	1	< 0.1%
-73.70075989	1	< 0.1%
-73.70077515	1	< 0.1%
-73.70095825	1	< 0.1%
-73.70096588	1	< 0.1%
-73.7009964	1	< 0.1%
-73.70117188	1	< 0.1%
-73.70121002	1	< 0.1%
-73.70127869	2	< 0.1%
-73.70161438	1	< 0.1%

geo_status
Categorical

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.8 MiB

Invalid	174320
Missing	6143

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	1263241
Distinct characters	10
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Invalid
2nd row	Invalid
3rd row	Invalid
4th row	Invalid
5th row	Invalid

Common Values

Value	Count	Frequency (%)
Invalid	174320	96.6%
Missing	6143	3.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
invalid	174320	96.6%
missing	6143	3.4%

Most occurring characters

Value	Count	Frequency (%)
i	186606	14.8%
n	180463	14.3%
I	174320	13.8%
v	174320	13.8%
a	174320	13.8%
l	174320	13.8%
d	174320	13.8%
s	12286	1.0%
M	6143	0.5%
g	6143	0.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1263241	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
i	186606	14.8%
n	180463	14.3%
I	174320	13.8%
v	174320	13.8%
a	174320	13.8%
l	174320	13.8%
d	174320	13.8%
s	12286	1.0%
M	6143	0.5%
g	6143	0.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1263241	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
i	186606	14.8%
n	180463	14.3%
I	174320	13.8%
v	174320	13.8%
a	174320	13.8%
l	174320	13.8%
d	174320	13.8%
s	12286	1.0%
M	6143	0.5%
g	6143	0.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1263241	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
i	186606	14.8%
n	180463	14.3%
I	174320	13.8%
v	174320	13.8%
a	174320	13.8%
l	174320	13.8%
d	174320	13.8%
s	12286	1.0%
M	6143	0.5%
g	6143	0.5%

location
Text

Missing

Distinct	87425
Distinct (%)	50.2%
Missing	6143
Missing (%)	3.4%
Memory size	2.8 MiB

Length

Max length	141
Median length	140
Mean length	140.05835
Min length	64

Characters and Unicode

Total characters	24414971
Distinct characters	38
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	59282 ?
Unique (%)	34.0%

Sample

1st row	{'longitude': '-74.07264521772677', 'latitude': '40.64414468130328', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}
2nd row	{'longitude': '-73.86716098015863', 'latitude': '40.6867859735264', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}
3rd row	{'longitude': '-74.00286802659268', 'latitude': '40.72085652445241', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}
4th row	{'longitude': '-73.8429876417836', 'latitude': '40.70994335729081', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}
5th row	{'longitude': '-73.89639140549146', 'latitude': '40.696914016789876', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}

Value	Count	Frequency (%)
	697268	30.8%
longitude	174320	7.7%
latitude	174320	7.7%
state	174317	7.7%
city	174317	7.7%
human_address	174317	7.7%
zip	174317	7.7%
address	174317	7.7%
40.72195913199264	509	< 0.1%
73.80969682426189	509	< 0.1%
Other values (174845)	347622	15.3%

Most occurring characters

Value	Count	Frequency (%)
"	2789072	11.4%
'	2091828	8.6%
	2091813	8.6%
:	1220225	5.0%
t	1045911	4.3%
d	1045908	4.3%
e	871591	3.6%
a	871588	3.6%
,	871588	3.6%
s	871585	3.6%
Other values (28)	10643862	43.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	24414971	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
"	2789072	11.4%
'	2091828	8.6%
	2091813	8.6%
:	1220225	5.0%
t	1045911	4.3%
d	1045908	4.3%
e	871591	3.6%
a	871588	3.6%
,	871588	3.6%
s	871585	3.6%
Other values (28)	10643862	43.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	24414971	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
"	2789072	11.4%
'	2091828	8.6%
	2091813	8.6%
:	1220225	5.0%
t	1045911	4.3%
d	1045908	4.3%
e	871591	3.6%
a	871588	3.6%
,	871588	3.6%
s	871585	3.6%
Other values (28)	10643862	43.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	24414971	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
"	2789072	11.4%
'	2091828	8.6%
	2091813	8.6%
:	1220225	5.0%
t	1045911	4.3%
d	1045908	4.3%
e	871591	3.6%
a	871588	3.6%
,	871588	3.6%
s	871585	3.6%
Other values (28)	10643862	43.6%

zip_codes
Real number (ℝ)

High correlation Missing

Distinct	214
Distinct (%)	0.1%
Missing	8411
Missing (%)	4.7%
Infinite	0
Infinite (%)	0.0%
Mean	14593.273

Minimum	10090
Maximum	24894
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.1 MiB

Quantile statistics

Minimum	10090
5-th percentile	10700
Q1	11723
median	13513
Q3	17212
95-th percentile	24015
Maximum	24894
Range	14804
Interquartile range (IQR)	5489

Descriptive statistics

Standard deviation	3641.4319
Coefficient of variation (CV)	0.24952811
Kurtosis	1.0668703
Mean	14593.273
Median Absolute Deviation (MAD)	1908
Skewness	1.2433916
Sum	2.5108019 × 10⁹
Variance	13260027
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13510	3166	1.8%
15310	2774	1.5%
11605	2704	1.5%
10935	2173	1.2%
17613	2125	1.2%
10931	2018	1.1%
11606	2010	1.1%
10930	1987	1.1%
12428	1956	1.1%
10936	1951	1.1%
Other values (204)	149188	82.7%
(Missing)	8411	4.7%

Value	Count	Frequency (%)
10090	451	0.2%
10091	41	< 0.1%
10092	341	0.2%
10093	10	< 0.1%
10094	5	< 0.1%
10095	6	< 0.1%
10096	3	< 0.1%
10097	1	< 0.1%
10098	26	< 0.1%
10099	717	0.4%

Value	Count	Frequency (%)
24894	3	< 0.1%
24672	7	< 0.1%
24671	407	0.2%
24670	1013	0.6%
24669	969	0.5%
24668	768	0.4%
24340	1119	0.6%
24339	183	0.1%
24338	396	0.2%
24337	338	0.2%

Request_Closing_Time
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	2.8 MiB

Request_Closing_Time_in_Hours
Real number (ℝ)

High correlation

Distinct	98161
Distinct (%)	54.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49.928009

Minimum	-1127
Maximum	1619.4422
Zeros	0
Zeros (%)	0.0%
Negative	1162
Negative (%)	0.6%
Memory size	2.8 MiB

Quantile statistics

Minimum	-1127
5-th percentile	1
Q1	2.9629167
median	9.0244444
Q3	47.294583
95-th percentile	243.06514
Maximum	1619.4422
Range	2746.4422
Interquartile range (IQR)	44.331667

Descriptive statistics

Standard deviation	124.37419
Coefficient of variation (CV)	2.4910704
Kurtosis	37.293513
Mean	49.928009
Median Absolute Deviation (MAD)	7.7572222
Skewness	4.5141019
Sum	9010158.3
Variance	15468.938
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	8058	4.5%
-71	184	0.1%
1.000277778	159	0.1%
1.000555556	146	0.1%
1.033333333	139	0.1%
-95	131	0.1%
1.016666667	118	0.1%
1.5	109	0.1%
1.066666667	80	< 0.1%
1.05	79	< 0.1%
Other values (98151)	171260	94.9%

Value	Count	Frequency (%)
-1127	5	< 0.1%
-1055.016667	2	< 0.1%
-1055	1	< 0.1%
-1031	4	< 0.1%
-1007.016667	2	< 0.1%
-1007	19	< 0.1%
-983.0166667	2	< 0.1%
-983	30	< 0.1%
-959	2	< 0.1%
-935	2	< 0.1%

Value	Count	Frequency (%)
1619.442222	1	< 0.1%
1616.298611	1	< 0.1%
1610.062778	1	< 0.1%
1588.381111	1	< 0.1%
1585.811111	1	< 0.1%
1583.920278	1	< 0.1%
1583.510556	1	< 0.1%
1583.062778	1	< 0.1%
1581.865833	1	< 0.1%
1577.207778	1	< 0.1%

Request_Closing_Time_in_Seconds
Unsupported

Rejected Unsupported

Missing	0
Missing (%)	0.0%
Memory size	2.8 MiB

Year-Month
Date

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.8 MiB

Minimum	2019-09-01 00:00:00
Maximum	2019-12-01 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=4)

Interactions

Correlations

	Request_Closing_Time_in_Hours	agency	borough	city	days_to_close	geo_status	incident_zip	latitude	longitude	status	unique_key	zip_codes
Request_Closing_Time_in_Hours	1.000	0.134	0.035	0.043	1.000	0.232	-0.045	0.072	0.018	0.483	-0.085	-0.082
agency	0.134	1.000	0.165	0.125	0.127	0.392	0.103	0.112	0.111	0.326	0.089	0.080
borough	0.035	0.165	1.000	0.921	0.024	0.318	0.690	0.572	0.614	0.024	0.027	0.609
city	0.043	0.125	0.921	1.000	0.028	0.158	0.846	0.530	0.637	0.034	0.038	0.757
days_to_close	1.000	0.127	0.024	0.028	1.000	0.010	-0.044	0.072	0.021	0.076	-0.083	-0.083
geo_status	0.232	0.392	0.318	0.158	0.010	1.000	0.026	1.000	1.000	0.220	0.031	1.000
incident_zip	-0.045	0.103	0.690	0.846	-0.044	0.026	1.000	-0.439	0.548	0.031	-0.002	0.717
latitude	0.072	0.112	0.572	0.530	0.072	1.000	-0.439	1.000	0.355	0.018	0.006	-0.516
longitude	0.018	0.111	0.614	0.637	0.021	1.000	0.548	0.355	1.000	0.024	0.005	0.217
status	0.483	0.326	0.024	0.034	0.076	0.220	0.031	0.018	0.024	1.000	0.041	0.019
unique_key	-0.085	0.089	0.027	0.038	-0.083	0.031	-0.002	0.006	0.005	0.041	1.000	-0.021
zip_codes	-0.082	0.080	0.609	0.757	-0.083	1.000	0.717	-0.516	0.217	0.019	-0.021	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

	unique_key	created_at	closed_at	resolution_date_update	resolution_description	days_to_close	agency	agency_name	complaint_type	descriptor	location_type	incident_zip	incident_address	city	facility_type	status	borough	latitude	longitude	geo_status	location	zip_codes	Request_Closing_Time	Request_Closing_Time_in_Hours	Request_Closing_Time_in_Seconds	Year-Month
4	43859987.0	2019-09-22 13:39:34	2019-09-24 08:36:11	2019-09-24 12:36:12	After performing a thorough search, the Department of Transportation was unable to find the lost ite	1.789317	DOT	Department of Transportation	Ferry Inquiry	Lost and Found	Bridge	10301.0	SAINT GEORGE FERRY	STATEN ISLAND	NaN	Closed	STATEN ISLAND	40.644146	-74.072647	Invalid	{'longitude': '-74.07264521772677', 'latitude': '40.64414468130328', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	10369.0	1 days 18:56:37	43.943611	1 days 18:56:37	2019-09
5	43859988.0	2019-09-22 15:27:37	2019-09-22 16:31:30	2019-09-22 20:31:32	The Police Department responded and upon arrival those responsible for the condition were gone.	0.044363	NYPD	New York City Police Department	Drinking	In Public	Street/Sidewalk	11208.0	600 RIDGEWOOD AVENUE	BROOKLYN	NaN	Closed	BROOKLYN	40.686787	-73.867165	Invalid	{'longitude': '-73.86716098015863', 'latitude': '40.6867859735264', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	17215.0	0 days 01:03:53	2.064722	0 days 01:03:53	2019-09
6	43859989.0	2019-09-22 23:16:10	2019-10-01 14:01:39	2019-09-26 21:52:45	NaN	8.614919	DOHMH	Department of Health and Mental Hygiene	Rodent	Rat Sighting	Street Area	10013.0	11 GREENE STREET	NEW YORK	NaN	Closed	MANHATTAN	40.720856	-74.002869	Invalid	{'longitude': '-74.00286802659268', 'latitude': '40.72085652445241', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	12076.0	8 days 14:45:29	207.758056	8 days 14:45:29	2019-09
7	43859990.0	2019-09-22 21:36:39	2019-09-22 21:36:40	NaT	NaN	0.000012	EDC	Economic Development Corporation	Noise - Helicopter	Other	Above Address	11375.0	101-21 75 ROAD	FOREST HILLS	NaN	Closed	QUEENS	40.709942	-73.842987	Invalid	{'longitude': '-73.8429876417836', 'latitude': '40.70994335729081', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	14786.0	0 days 00:00:01	1.000278	0 days 00:00:01	2019-09
8	43859991.0	2019-09-22 14:43:29	2019-09-22 14:44:43	2019-09-22 18:44:48	The agency was unable to respond to this complaint because they allocated resources to other critica	0.000856	DPR	Department of Parks and Recreation	Violation of Park Rules	Smoking	Park	11385.0	60-09 SAINT FELIX AVENUE	RIDGEWOOD	NaN	Closed	QUEENS	40.696915	-73.896393	Invalid	{'longitude': '-73.89639140549146', 'latitude': '40.696914016789876', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	15310.0	0 days 00:01:14	1.020556	0 days 00:01:14	2019-09
19	43860006.0	2019-09-22 12:42:00	2019-09-22 12:42:00	2019-09-22 12:42:00	The Department of Sanitation removed the items.	0.000000	DSNY	BCC - Queens East	Derelict Vehicles	14 Derelict Vehicles	Street	11413.0	143-50 229 STREET	SPRINGFIELD GARDENS	DSNY Garage	Closed	QUEENS	40.664200	-73.749046	Invalid	{'longitude': '-73.74904961976131', 'latitude': '40.6641997943848', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	15313.0	0 days 00:00:00	1.000000	0 days 00:00:00	2019-09
20	43860007.0	2019-09-22 12:07:00	2019-09-22 12:07:00	2019-09-22 12:07:00	The Department of Sanitation removed the items.	0.000000	DSNY	BCC - Queens West	Derelict Vehicles	14 Derelict Vehicles	Street	11416.0	97-25 106 STREET	OZONE PARK	DSNY Garage	Closed	QUEENS	40.688175	-73.837967	Invalid	{'longitude': '-73.83796551186634', 'latitude': '40.688175850538464', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	24012.0	0 days 00:00:00	1.000000	0 days 00:00:00	2019-09
34	43860023.0	2019-09-22 21:25:06	2019-09-23 12:06:30	2019-09-23 16:06:34	The Police Department responded to the complaint and determined that police action was not necessary	0.612083	NYPD	New York City Police Department	Homeless Encampment	NaN	Street/Sidewalk	10075.0	315 EAST 77 STREET	NEW YORK	NaN	Closed	MANHATTAN	40.771778	-73.955421	Invalid	{'longitude': '-73.95541952970686', 'latitude': '40.771779498956356', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	10092.0	0 days 14:41:24	15.690000	0 days 14:41:24	2019-09
44	43860038.0	2019-09-22 22:03:01	2019-09-23 17:31:13	2019-09-23 21:31:17	The Police Department responded to the complaint and took action to fix the condition.	0.811250	NYPD	New York City Police Department	Illegal Parking	Commercial Overnight Parking	Street/Sidewalk	11230.0	1036 OCEAN PARKWAY	BROOKLYN	NaN	Closed	BROOKLYN	40.623291	-73.970314	Invalid	{'longitude': '-73.97031698905789', 'latitude': '40.62328968281543', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	13513.0	0 days 19:28:12	20.470000	0 days 19:28:12	2019-09
45	43860039.0	2019-09-22 21:12:47	2019-09-23 02:42:06	2019-09-23 06:42:10	The Police Department responded to the complaint and with the information available observed no evid	0.228692	NYPD	New York City Police Department	Illegal Parking	Commercial Overnight Parking	Street/Sidewalk	11236.0	1138 EAST 108 STREET	BROOKLYN	NaN	Closed	BROOKLYN	40.644905	-73.888107	Invalid	{'longitude': '-73.88810849849925', 'latitude': '40.64490369132947', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	13827.0	0 days 05:29:19	6.488611	0 days 05:29:19	2019-09

	unique_key	created_at	closed_at	resolution_date_update	resolution_description	days_to_close	agency	agency_name	complaint_type	descriptor	location_type	incident_zip	incident_address	city	facility_type	status	borough	latitude	longitude	geo_status	location	zip_codes	Request_Closing_Time	Request_Closing_Time_in_Hours	Request_Closing_Time_in_Seconds	Year-Month
209956	45054955.0	2019-11-30 13:19:55	2019-11-30 18:08:50	2019-11-30 18:08:50	The Department of Housing Preservation and Development conducted or attempted to conduct an inspection. More information about inspection results can be found through HPD's website at www.nyc.gov/hpd by using HPDONLINE (enter your address on the home page) and entering your SR number under the complaint status option.	0.200637	HPD	Department of Housing Preservation and Development	HEAT/HOT WATER	ENTIRE BUILDING	RESIDENTIAL BUILDING	11226.0	1060 ROGERS AVENUE	BROOKLYN	NaN	Closed	BROOKLYN	40.644047	-73.951767	Invalid	{'longitude': '-73.95176811885132', 'latitude': '40.64404497558585', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	0 days 04:48:55	5.815278	0 days 04:48:55	2019-11
209957	45054956.0	2019-11-30 15:33:25	2019-11-30 15:44:26	2019-11-30 20:44:28	The Department of Parks and Recreation has completed the requested work order and corrected the prob	0.007650	DPR	Department of Parks and Recreation	Violation of Park Rules	Obstructing Public Use	Park	10472.0	ROSEDALE AVENUE	NaN	NaN	Closed	BRONX	40.827427	-73.868225	Invalid	{'longitude': '-73.86822438047447', 'latitude': '40.82742530197013', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	0 days 00:11:01	1.183611	0 days 00:11:01	2019-11
209959	45054958.0	2019-11-30 14:22:42	2019-11-30 19:13:11	2019-12-01 00:13:17	The Police Department responded to the complaint and determined that police action was not necessary	0.201725	NYPD	New York City Police Department	Illegal Parking	Parking Permit Improper Use	Street/Sidewalk	10075.0	1 CHEROKEE PLACE	NEW YORK	NaN	Closed	MANHATTAN	40.769566	-73.949875	Invalid	{'longitude': '-73.9498757147109', 'latitude': '40.76956496035729', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	0 days 04:50:29	5.841389	0 days 04:50:29	2019-11
209980	45054980.0	2019-11-30 21:46:44	2019-11-30 23:26:37	2019-12-01 04:26:40	The Police Department responded to the complaint and with the information available observed no evid	0.069363	NYPD	New York City Police Department	Noise - Residential	Loud Music/Party	Residential Building/House	11238.0	520 CLINTON AVENUE	BROOKLYN	NaN	Closed	BROOKLYN	40.682648	-73.966736	Invalid	{'longitude': '-73.96673913670575', 'latitude': '40.68264735984039', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	0 days 01:39:53	2.664722	0 days 01:39:53	2019-11
209981	45054981.0	2019-11-30 21:55:41	2019-11-30 22:35:42	2019-12-01 03:35:45	The Police Department responded to the complaint and with the information available observed no evid	0.027789	NYPD	New York City Police Department	Noise - Residential	Banging/Pounding	Residential Building/House	10039.0	220 WEST 149 STREET	NEW YORK	NaN	Closed	MANHATTAN	40.824554	-73.938126	Invalid	{'longitude': '-73.93812389996073', 'latitude': '40.824555379608164', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	0 days 00:40:01	1.666944	0 days 00:40:01	2019-11
209990	45054991.0	2019-11-28 15:42:15	2019-11-29 21:10:00	2019-11-29 21:10:00	The Department of Transportation inspected this complaint and repaired the problem.	1.227604	DOT	Department of Transportation	Street Condition	Pothole	NaN	11201.0	NaN	BROOKLYN	NaN	Closed	BROOKLYN	40.695953	-73.982391	Invalid	{'longitude': '-73.98239076393166', 'latitude': '40.69595197545211', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	1 days 05:27:45	30.462500	1 days 05:27:45	2019-11
209991	45054992.0	2019-11-28 15:44:43	2019-11-29 22:15:00	2019-11-29 22:15:00	The Department of Transportation inspected this complaint and repaired the problem.	1.271030	DOT	Department of Transportation	Street Condition	Pothole	NaN	11206.0	SEIGEL STREET	BROOKLYN	NaN	Closed	BROOKLYN	NaN	NaN	Missing	NaN	NaN	1 days 06:30:17	31.504722	1 days 06:30:17	2019-11
209992	45054993.0	2019-11-28 15:45:44	2019-11-29 22:30:00	2019-11-29 22:30:00	The Department of Transportation inspected this complaint and repaired the problem.	1.280741	DOT	Department of Transportation	Street Condition	Pothole	NaN	11206.0	NaN	BROOKLYN	NaN	Closed	BROOKLYN	40.701797	-73.940544	Invalid	{'longitude': '-73.94054603053874', 'latitude': '40.70179804436484', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	1 days 06:44:16	31.737778	1 days 06:44:16	2019-11
209993	45054994.0	2019-11-28 15:38:20	2019-11-29 15:55:00	2019-11-29 15:55:00	The Department of Transportation inspected this complaint and repaired the problem.	1.011574	DOT	Department of Transportation	Street Condition	Pothole	NaN	11102.0	ASTORIA BOULEVARD	ASTORIA	NaN	Closed	QUEENS	40.772133	-73.929565	Invalid	{'longitude': '-73.92956190226768', 'latitude': '40.772131643406595', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	1 days 00:16:40	25.277778	1 days 00:16:40	2019-11
209994	45054995.0	2019-11-30 22:59:49	2019-12-01 00:53:03	2019-12-01 05:53:05	The Police Department responded to the complaint and determined that police action was not necessary	0.078634	NYPD	New York City Police Department	Panhandling	NaN	Store/Commercial	10038.0	160 BROADWAY	NEW YORK	NaN	Closed	MANHATTAN	40.709492	-74.010239	Invalid	{'longitude': '-74.01024017537995', 'latitude': '40.70949279464519', 'human_address': '{"address": "", "city": "", "state": "", "zip": ""}'}	NaN	0 days 01:53:14	2.887222	0 days 01:53:14	2019-11

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)